<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>PrestaShop 的 CSV 导入</title>
<link rel="stylesheet" href="../css/reset.css" type="text/css" />
<link rel="stylesheet" href="../css/prettify.css" type="text/css" />
<script type="text/javascript" src="../js/prettify.js"></script>
</head>

<body onload="prettyPrint()">
<h1>PrestaShop 的 CSV 导入</h1>
<hr />
<h3>导入商品</h3>
<table>
  <tr>
    <th>文档中的CSV</th>
    <th>1.4.6.2的CSV</th>
  </tr>
  <tr>
    <td style="vertical-align:top;"><ol>
        <li>id; 【商品ID】</li>
        <li>Active (0/1); 【是否启用】</li>
        <li>Name*; 【商品名称】</li>
        <li>Categories (x,y,z,...); 【所属分类】</li>
        <li>Price tax excl. Or Price tax excl; 【含税价】</li>
        <li>Tax rules id; 【计税规则ID】</li>
        <li>Wholesale price; 【批发价格】</li>
        <li>On sale (0/1); 【是否在售】</li>
        <li>Discount amount; 【折扣金额】</li>
        <li>Discount percent; 【折扣百分数】</li>
        <li>Discount from (yyy-mm-dd); 【折扣起始日】</li>
        <li>Discount to (yyy-mm-dd); 【折扣结束日】</li>
        <li>Reference #; 【参考】</li>
        <li>Supplier reference #; 【供应商参考】</li>
        <li>Supplier; 【供应商】</li>
        <li>Manufacturer; 【生产商】</li>
        <li>EAN13; 【EAN条码】</li>
        <li>UPC; 【UPC条码】</li>
        <li>Ecotax; 【生态税】</li>
        <li>Weight; 【重量】</li>
        <li>Quantity; 【数量】</li>
        <li>Short description; 【简述】</li>
        <li>Description; 【介绍】</li>
        <li>Tags (x,y,z,...); 【标签】</li>
        <li>Meta-title; 【Meta标题】</li>
        <li>Meta-keywords; 【Meta关键词】</li>
        <li>Meta-description; 【Meta描述】</li>
        <li>URL rewritten; 【URL重写】</li>
        <li>Text when in-stock; 【有库存时显示的字样】</li>
        <li>Text if back-order allowed; 【缺货但可订购的字样】</li>
        <li>Image URLs (x,y,z,...); 【图片URLs】</li>
        <li>Feature; 【功能】</li>
        <li>Only available online 【只在线销售】</li>
      </ol></td>
    <td style="vertical-align:top;"><ol>
        <li>ID 【商品ID】</li>
        <li> Active (0/1) 【是否启用】</li>
        <li> Name * 【商品名称】</li>
        <li> Categories (x,y,z...) 【商品分类】</li>
        <li> Price tax excl. 【含税价】</li>
        <li> Tax rules ID 【计税规则ID】</li>
        <li> Wholesale price 【批发价】</li>
        <li> On sale (0/1) 【是否在售】</li>
        <li> Discount amount 【折扣数量】</li>
        <li> Discount percent 【折扣百分比】</li>
        <li> Discount from (yyyy-mm-dd) 【优惠起始日】</li>
        <li> Discount to (yyyy-mm-dd) 【优惠结束日】</li>
        <li> Reference # 【参考】</li>
        <li> Supplier reference # 【供应商参考】</li>
        <li> Supplier 【供应商】</li>
        <li> Manufacturer 【生产商】</li>
        <li> EAN13 【条码】</li>
        <li> UPC 【UPC条码】</li>
        <li> Ecotax 【生态税】</li>
        <li> Weight 【重量】</li>
        <li> Quantity 【数量】</li>
        <li> Short description 【简述】</li>
        <li> Description 【介绍】</li>
        <li> Tags (x,y,z...)【标签】</li>
        <li> Meta-title 【Meta标题】</li>
        <li> Meta-keywords 【Meta关键词】</li>
        <li> Meta-description 【Meta描述】</li>
        <li> URL rewritten 【URL重写】</li>
        <li> Text when in stock 【有库存时显示的字样】</li>
        <li> Text when backorder allowed 【缺货但可订购时显示的字样】</li>
        <li> <strong style="color:red;">Available for order 【可以订购】</strong></li>
        <li> <strong style="color:red;">Product creation date 【商品创建日期】</strong></li>
        <li> <strong style="color:red;">Show price 【是否显示价格】</strong></li>
        <li> Image URLs (x,y,z...) 【图片URLs】</li>
        <li> <strong style="color:red;">Delete existing images (0 = No, 1 = Yes) 【删除已存在的图片】</strong></li>
        <li> Feature 【功能】</li>
        <li> Available online only 【仅在线销售】</li>
        <li> <strong style="color:red;">Condition 【条件】</strong></li>
      </ol></td>
  </tr>
</table>
<hr />
<h3>文档中的CSV</h3>
<pre class="prettyprint linenums">
id;Active (0/1);Name*;Categories (x,y,z,...);Price tax excl. Or Price tax excl;Tax rules id;Wholesale price;On sale (0/1);Discount amount;Discount percent;Discount from (yyy-mm-dd);Discount to (yyy-mm-dd);Reference #;Supplier reference #;Supplier;Manufacturer;EAN13;UPC;Ecotax;Weight;Quantity;Short description;Description;Tags (x,y,z,...);Meta-title;Meta-keywords;Meta-description;URL rewritten;Text when in-stock;Text if back-order allowed;Image URLs (x,y,z,...);Feature;Only available online
1;1;iPod Nano;Home, iPods;49;1;;1;;;;;92458844;54778855;AppleStore;Apple Computer, Inc;;;;0.5;800;New design. New features. Now i….;Curved ahead of the curve. For those about to rock, we give you nine amazing colors. But that's only part of the story. Feel the curved, all-aluminum and glass de...;apple, ipod, nano;;;;ipod-nano;In stock;;http://youdomain.com/img.jpg, http://yourdomain.com/img1.jpg;;
2;1;iPod shuffle;Home, iPods;66.05;1;79;1;;;;;92458845;54778855;AppleStore;Apple Computer, Inc;;;;0;500;iPod shuffle, the world's most wearabl….;;ipod, shuffle;;;;ipod-shuffle;In stock;;http://youdomain.com/img25.jpg, http://yourdomain.com/img30.jpg;;

</pre>
<hr />
<h3>实际可用的CSV</h3>
<pre class="prettyprint linenums">
10;1;贺兰山美域经典赤霞珠;1;98;0;68;1;;;;;CSV录入;九红;;;6925392607382;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/07382-06.jpg,../upload/69253926/07382-12.jpg;0;;0;new
11;1;贺兰山美域经典梅洛;1;98;0;68;1;;;;;CSV录入;九红;;;6925392607405;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/07405-06.jpg,../upload/69253926/07405-12.jpg;0;;0;new
12;1;贺兰山美域经典霞多丽;1;98;0;68;1;;;;;CSV录入;九红;;;6925392607412;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/07412-06.jpg,../upload/69253926/07412-12.jpg;0;;0;new
13;1;贺兰山美域特选赤霞珠;1;148;0;88;1;;;;;CSV录入;九红;;;6925392607436;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/07436-06.jpg,../upload/69253926/07436-12.jpg;0;;0;new
14;1;贺兰山美域特选霞多丽;1;148;0;88;1;;;;;CSV录入;九红;;;6925392607467;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/07467-06.jpg,../upload/69253926/07467-12.jpg;0;;0;new
15;1;贺兰山夜光精制赤霞珠;1;48;0;25;1;;;;;CSV录入;九红;;;6925392609447;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/09447-06.jpg,../upload/69253926/09447-12.jpg;0;;0;new
16;1;贺兰山夜光精制干红;1;;0;;1;;;;;CSV录入;九红;;;6925392608709;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/08709-06.jpg,../upload/69253926/08709-12.jpg;0;;0;new
17;1;贺兰山夜光精制卡本尼特;1;;0;;1;;;;;CSV录入;九红;;;6925392609454;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/09454-06.jpg,../upload/69253926/09454-12.jpg;0;;0;new
18;1;贺兰山夜光特制赤霞珠;1;38;0;20;1;;;;;CSV录入;九红;;;6925392609461;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/09461-06.jpg,../upload/69253926/09461-12.jpg;0;;0;new
19;1;贺兰山夜光特制干红;1;;0;;1;;;;;CSV录入;九红;;;6925392608693;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/08693-06.jpg,../upload/69253926/08693-12.jpg;0;;0;new
20;1;贺兰山夜光特制卡本尼特;1;;0;;1;;;;;CSV录入;九红;;;6925392609478;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/09478-06.jpg,../upload/69253926/09478-12.jpg;0;;0;new
21;1;贺兰山优选赤霞珠;1;88;0;46;1;;;;;CSV录入;九红;;;6925392650883;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/50883-06.jpg,../upload/69253926/50883-12.jpg;0;;0;new
22;1;贺兰山优选干红;1;78;0;50;1;;;;;CSV录入;九红;;;6925392607368;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/07368-06.jpg,../upload/69253926/07368-12.jpg;0;;0;new
23;1;贺兰山优选卡本尼特;1;88;0;55;1;;;;;CSV录入;九红;;;6925392608983;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/08983-06.jpg,../upload/69253926/08983-12.jpg;0;;0;new
24;1;贺兰山珍藏级赤霞珠;1;388;0;200;1;;;;;CSV录入;九红;;;6925392607481;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/07481-06.jpg,../upload/69253926/07481-12.jpg;0;;0;new
25;;贺兰山珍藏级霞多丽;1;388;0;200;;;;;;CSV录入;九红;;;69253926;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/-06.jpg,../upload/69253926/-12.jpg;0;;0;new
26;1;贺兰山优选干白;1;78;0;50;1;;;;;CSV录入;九红;;;6925392609375;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/09375-06.jpg,../upload/69253926/09375-12.jpg;0;;0;new
27;;贺兰山美域经典卡本尼特;1;138;0;75;;;;;;CSV录入;九红;;;69253926;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/-06.jpg,../upload/69253926/-12.jpg;0;;0;new
28;1;贺兰山美域特选梅洛;1;148;0;88;1;;;;;CSV录入;九红;;;6925392607450;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/07450-06.jpg,../upload/69253926/07450-12.jpg;0;;0;new
29;;贺兰山美域特选卡本尼特;1;168;0;105;;;;;;CSV录入;九红;;;69253926;;;;10;;;;Meta标题;Meta关键词;Meta描述;hlm;立刻购买;暂无库存;1;;1;../upload/69253926/-06.jpg,../upload/69253926/-12.jpg;0;;0;new

</pre>
<hr />

</body>
</html>
